package com.quanyan.place.entity;

import com.quanyan.common.Plugin.Page;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class TbBizPlacePromotionRewardStatementsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Page page;

    public TbBizPlacePromotionRewardStatementsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPage(Page page) {
        this.page=page;
    }

    public Page getPage() {
        return page;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andStatementNoIsNull() {
            addCriterion("statement_no is null");
            return (Criteria) this;
        }

        public Criteria andStatementNoIsNotNull() {
            addCriterion("statement_no is not null");
            return (Criteria) this;
        }

        public Criteria andStatementNoEqualTo(String value) {
            addCriterion("statement_no =", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoNotEqualTo(String value) {
            addCriterion("statement_no <>", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoGreaterThan(String value) {
            addCriterion("statement_no >", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoGreaterThanOrEqualTo(String value) {
            addCriterion("statement_no >=", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoLessThan(String value) {
            addCriterion("statement_no <", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoLessThanOrEqualTo(String value) {
            addCriterion("statement_no <=", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoLike(String value) {
            addCriterion("statement_no like", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoNotLike(String value) {
            addCriterion("statement_no not like", value, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoIn(List<String> values) {
            addCriterion("statement_no in", values, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoNotIn(List<String> values) {
            addCriterion("statement_no not in", values, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoBetween(String value1, String value2) {
            addCriterion("statement_no between", value1, value2, "statementNo");
            return (Criteria) this;
        }

        public Criteria andStatementNoNotBetween(String value1, String value2) {
            addCriterion("statement_no not between", value1, value2, "statementNo");
            return (Criteria) this;
        }

        public Criteria andPlaceIdIsNull() {
            addCriterion("place_id is null");
            return (Criteria) this;
        }

        public Criteria andPlaceIdIsNotNull() {
            addCriterion("place_id is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceIdEqualTo(Integer value) {
            addCriterion("place_id =", value, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdNotEqualTo(Integer value) {
            addCriterion("place_id <>", value, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdGreaterThan(Integer value) {
            addCriterion("place_id >", value, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("place_id >=", value, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdLessThan(Integer value) {
            addCriterion("place_id <", value, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdLessThanOrEqualTo(Integer value) {
            addCriterion("place_id <=", value, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdIn(List<Integer> values) {
            addCriterion("place_id in", values, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdNotIn(List<Integer> values) {
            addCriterion("place_id not in", values, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdBetween(Integer value1, Integer value2) {
            addCriterion("place_id between", value1, value2, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("place_id not between", value1, value2, "placeId");
            return (Criteria) this;
        }

        public Criteria andPlaceNameIsNull() {
            addCriterion("place_name is null");
            return (Criteria) this;
        }

        public Criteria andPlaceNameIsNotNull() {
            addCriterion("place_name is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceNameEqualTo(String value) {
            addCriterion("place_name =", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameNotEqualTo(String value) {
            addCriterion("place_name <>", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameGreaterThan(String value) {
            addCriterion("place_name >", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameGreaterThanOrEqualTo(String value) {
            addCriterion("place_name >=", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameLessThan(String value) {
            addCriterion("place_name <", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameLessThanOrEqualTo(String value) {
            addCriterion("place_name <=", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameLike(String value) {
            addCriterion("place_name like", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameNotLike(String value) {
            addCriterion("place_name not like", value, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameIn(List<String> values) {
            addCriterion("place_name in", values, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameNotIn(List<String> values) {
            addCriterion("place_name not in", values, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameBetween(String value1, String value2) {
            addCriterion("place_name between", value1, value2, "placeName");
            return (Criteria) this;
        }

        public Criteria andPlaceNameNotBetween(String value1, String value2) {
            addCriterion("place_name not between", value1, value2, "placeName");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNull() {
            addCriterion("city_id is null");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNotNull() {
            addCriterion("city_id is not null");
            return (Criteria) this;
        }

        public Criteria andCityIdEqualTo(Integer value) {
            addCriterion("city_id =", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotEqualTo(Integer value) {
            addCriterion("city_id <>", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThan(Integer value) {
            addCriterion("city_id >", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("city_id >=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThan(Integer value) {
            addCriterion("city_id <", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThanOrEqualTo(Integer value) {
            addCriterion("city_id <=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdIn(List<Integer> values) {
            addCriterion("city_id in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotIn(List<Integer> values) {
            addCriterion("city_id not in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdBetween(Integer value1, Integer value2) {
            addCriterion("city_id between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("city_id not between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andUidIsNull() {
            addCriterion("uid is null");
            return (Criteria) this;
        }

        public Criteria andUidIsNotNull() {
            addCriterion("uid is not null");
            return (Criteria) this;
        }

        public Criteria andUidEqualTo(Integer value) {
            addCriterion("uid =", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotEqualTo(Integer value) {
            addCriterion("uid <>", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThan(Integer value) {
            addCriterion("uid >", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidGreaterThanOrEqualTo(Integer value) {
            addCriterion("uid >=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThan(Integer value) {
            addCriterion("uid <", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidLessThanOrEqualTo(Integer value) {
            addCriterion("uid <=", value, "uid");
            return (Criteria) this;
        }

        public Criteria andUidIn(List<Integer> values) {
            addCriterion("uid in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotIn(List<Integer> values) {
            addCriterion("uid not in", values, "uid");
            return (Criteria) this;
        }

        public Criteria andUidBetween(Integer value1, Integer value2) {
            addCriterion("uid between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andUidNotBetween(Integer value1, Integer value2) {
            addCriterion("uid not between", value1, value2, "uid");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIsNull() {
            addCriterion("account_number is null");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIsNotNull() {
            addCriterion("account_number is not null");
            return (Criteria) this;
        }

        public Criteria andAccountNumberEqualTo(String value) {
            addCriterion("account_number =", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotEqualTo(String value) {
            addCriterion("account_number <>", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberGreaterThan(String value) {
            addCriterion("account_number >", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberGreaterThanOrEqualTo(String value) {
            addCriterion("account_number >=", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLessThan(String value) {
            addCriterion("account_number <", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLessThanOrEqualTo(String value) {
            addCriterion("account_number <=", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberLike(String value) {
            addCriterion("account_number like", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotLike(String value) {
            addCriterion("account_number not like", value, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberIn(List<String> values) {
            addCriterion("account_number in", values, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotIn(List<String> values) {
            addCriterion("account_number not in", values, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberBetween(String value1, String value2) {
            addCriterion("account_number between", value1, value2, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAccountNumberNotBetween(String value1, String value2) {
            addCriterion("account_number not between", value1, value2, "accountNumber");
            return (Criteria) this;
        }

        public Criteria andAdminMobileIsNull() {
            addCriterion("admin_mobile is null");
            return (Criteria) this;
        }

        public Criteria andAdminMobileIsNotNull() {
            addCriterion("admin_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andAdminMobileEqualTo(String value) {
            addCriterion("admin_mobile =", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotEqualTo(String value) {
            addCriterion("admin_mobile <>", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileGreaterThan(String value) {
            addCriterion("admin_mobile >", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileGreaterThanOrEqualTo(String value) {
            addCriterion("admin_mobile >=", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileLessThan(String value) {
            addCriterion("admin_mobile <", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileLessThanOrEqualTo(String value) {
            addCriterion("admin_mobile <=", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileLike(String value) {
            addCriterion("admin_mobile like", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotLike(String value) {
            addCriterion("admin_mobile not like", value, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileIn(List<String> values) {
            addCriterion("admin_mobile in", values, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotIn(List<String> values) {
            addCriterion("admin_mobile not in", values, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileBetween(String value1, String value2) {
            addCriterion("admin_mobile between", value1, value2, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andAdminMobileNotBetween(String value1, String value2) {
            addCriterion("admin_mobile not between", value1, value2, "adminMobile");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateIsNull() {
            addCriterion("statement_start_date is null");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateIsNotNull() {
            addCriterion("statement_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateEqualTo(Date value) {
            addCriterionForJDBCDate("statement_start_date =", value, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("statement_start_date <>", value, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateGreaterThan(Date value) {
            addCriterionForJDBCDate("statement_start_date >", value, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("statement_start_date >=", value, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateLessThan(Date value) {
            addCriterionForJDBCDate("statement_start_date <", value, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("statement_start_date <=", value, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateIn(List<Date> values) {
            addCriterionForJDBCDate("statement_start_date in", values, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("statement_start_date not in", values, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("statement_start_date between", value1, value2, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementStartDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("statement_start_date not between", value1, value2, "statementStartDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateIsNull() {
            addCriterion("statement_end_date is null");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateIsNotNull() {
            addCriterion("statement_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateEqualTo(Date value) {
            addCriterionForJDBCDate("statement_end_date =", value, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("statement_end_date <>", value, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateGreaterThan(Date value) {
            addCriterionForJDBCDate("statement_end_date >", value, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("statement_end_date >=", value, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateLessThan(Date value) {
            addCriterionForJDBCDate("statement_end_date <", value, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("statement_end_date <=", value, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateIn(List<Date> values) {
            addCriterionForJDBCDate("statement_end_date in", values, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("statement_end_date not in", values, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("statement_end_date between", value1, value2, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andStatementEndDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("statement_end_date not between", value1, value2, "statementEndDate");
            return (Criteria) this;
        }

        public Criteria andRewardAmountIsNull() {
            addCriterion("reward_amount is null");
            return (Criteria) this;
        }

        public Criteria andRewardAmountIsNotNull() {
            addCriterion("reward_amount is not null");
            return (Criteria) this;
        }

        public Criteria andRewardAmountEqualTo(BigDecimal value) {
            addCriterion("reward_amount =", value, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountNotEqualTo(BigDecimal value) {
            addCriterion("reward_amount <>", value, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountGreaterThan(BigDecimal value) {
            addCriterion("reward_amount >", value, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("reward_amount >=", value, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountLessThan(BigDecimal value) {
            addCriterion("reward_amount <", value, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("reward_amount <=", value, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountIn(List<BigDecimal> values) {
            addCriterion("reward_amount in", values, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountNotIn(List<BigDecimal> values) {
            addCriterion("reward_amount not in", values, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("reward_amount between", value1, value2, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andRewardAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("reward_amount not between", value1, value2, "rewardAmount");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxIsNull() {
            addCriterion("personal_tax is null");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxIsNotNull() {
            addCriterion("personal_tax is not null");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxEqualTo(BigDecimal value) {
            addCriterion("personal_tax =", value, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxNotEqualTo(BigDecimal value) {
            addCriterion("personal_tax <>", value, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxGreaterThan(BigDecimal value) {
            addCriterion("personal_tax >", value, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("personal_tax >=", value, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxLessThan(BigDecimal value) {
            addCriterion("personal_tax <", value, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("personal_tax <=", value, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxIn(List<BigDecimal> values) {
            addCriterion("personal_tax in", values, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxNotIn(List<BigDecimal> values) {
            addCriterion("personal_tax not in", values, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("personal_tax between", value1, value2, "personalTax");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("personal_tax not between", value1, value2, "personalTax");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeIsNull() {
            addCriterion("after_tax_income is null");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeIsNotNull() {
            addCriterion("after_tax_income is not null");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeEqualTo(BigDecimal value) {
            addCriterion("after_tax_income =", value, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeNotEqualTo(BigDecimal value) {
            addCriterion("after_tax_income <>", value, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeGreaterThan(BigDecimal value) {
            addCriterion("after_tax_income >", value, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("after_tax_income >=", value, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeLessThan(BigDecimal value) {
            addCriterion("after_tax_income <", value, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("after_tax_income <=", value, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeIn(List<BigDecimal> values) {
            addCriterion("after_tax_income in", values, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeNotIn(List<BigDecimal> values) {
            addCriterion("after_tax_income not in", values, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("after_tax_income between", value1, value2, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andAfterTaxIncomeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("after_tax_income not between", value1, value2, "afterTaxIncome");
            return (Criteria) this;
        }

        public Criteria andStatementStatusIsNull() {
            addCriterion("statement_status is null");
            return (Criteria) this;
        }

        public Criteria andStatementStatusIsNotNull() {
            addCriterion("statement_status is not null");
            return (Criteria) this;
        }

        public Criteria andStatementStatusEqualTo(Byte value) {
            addCriterion("statement_status =", value, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusNotEqualTo(Byte value) {
            addCriterion("statement_status <>", value, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusGreaterThan(Byte value) {
            addCriterion("statement_status >", value, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusGreaterThanOrEqualTo(Byte value) {
            addCriterion("statement_status >=", value, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusLessThan(Byte value) {
            addCriterion("statement_status <", value, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusLessThanOrEqualTo(Byte value) {
            addCriterion("statement_status <=", value, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusIn(List<Byte> values) {
            addCriterion("statement_status in", values, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusNotIn(List<Byte> values) {
            addCriterion("statement_status not in", values, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusBetween(Byte value1, Byte value2) {
            addCriterion("statement_status between", value1, value2, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andStatementStatusNotBetween(Byte value1, Byte value2) {
            addCriterion("statement_status not between", value1, value2, "statementStatus");
            return (Criteria) this;
        }

        public Criteria andTransferNameIsNull() {
            addCriterion("transfer_name is null");
            return (Criteria) this;
        }

        public Criteria andTransferNameIsNotNull() {
            addCriterion("transfer_name is not null");
            return (Criteria) this;
        }

        public Criteria andTransferNameEqualTo(String value) {
            addCriterion("transfer_name =", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameNotEqualTo(String value) {
            addCriterion("transfer_name <>", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameGreaterThan(String value) {
            addCriterion("transfer_name >", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_name >=", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameLessThan(String value) {
            addCriterion("transfer_name <", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameLessThanOrEqualTo(String value) {
            addCriterion("transfer_name <=", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameLike(String value) {
            addCriterion("transfer_name like", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameNotLike(String value) {
            addCriterion("transfer_name not like", value, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameIn(List<String> values) {
            addCriterion("transfer_name in", values, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameNotIn(List<String> values) {
            addCriterion("transfer_name not in", values, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameBetween(String value1, String value2) {
            addCriterion("transfer_name between", value1, value2, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferNameNotBetween(String value1, String value2) {
            addCriterion("transfer_name not between", value1, value2, "transferName");
            return (Criteria) this;
        }

        public Criteria andTransferDateIsNull() {
            addCriterion("transfer_date is null");
            return (Criteria) this;
        }

        public Criteria andTransferDateIsNotNull() {
            addCriterion("transfer_date is not null");
            return (Criteria) this;
        }

        public Criteria andTransferDateEqualTo(Date value) {
            addCriterionForJDBCDate("transfer_date =", value, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("transfer_date <>", value, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateGreaterThan(Date value) {
            addCriterionForJDBCDate("transfer_date >", value, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("transfer_date >=", value, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateLessThan(Date value) {
            addCriterionForJDBCDate("transfer_date <", value, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("transfer_date <=", value, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateIn(List<Date> values) {
            addCriterionForJDBCDate("transfer_date in", values, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("transfer_date not in", values, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("transfer_date between", value1, value2, "transferDate");
            return (Criteria) this;
        }

        public Criteria andTransferDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("transfer_date not between", value1, value2, "transferDate");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNull() {
            addCriterion("bank_account is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNotNull() {
            addCriterion("bank_account is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEqualTo(String value) {
            addCriterion("bank_account =", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotEqualTo(String value) {
            addCriterion("bank_account <>", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThan(String value) {
            addCriterion("bank_account >", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("bank_account >=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThan(String value) {
            addCriterion("bank_account <", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThanOrEqualTo(String value) {
            addCriterion("bank_account <=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLike(String value) {
            addCriterion("bank_account like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotLike(String value) {
            addCriterion("bank_account not like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountIn(List<String> values) {
            addCriterion("bank_account in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotIn(List<String> values) {
            addCriterion("bank_account not in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountBetween(String value1, String value2) {
            addCriterion("bank_account between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotBetween(String value1, String value2) {
            addCriterion("bank_account not between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkIsNull() {
            addCriterion("transfer_remark is null");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkIsNotNull() {
            addCriterion("transfer_remark is not null");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkEqualTo(String value) {
            addCriterion("transfer_remark =", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkNotEqualTo(String value) {
            addCriterion("transfer_remark <>", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkGreaterThan(String value) {
            addCriterion("transfer_remark >", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("transfer_remark >=", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkLessThan(String value) {
            addCriterion("transfer_remark <", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkLessThanOrEqualTo(String value) {
            addCriterion("transfer_remark <=", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkLike(String value) {
            addCriterion("transfer_remark like", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkNotLike(String value) {
            addCriterion("transfer_remark not like", value, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkIn(List<String> values) {
            addCriterion("transfer_remark in", values, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkNotIn(List<String> values) {
            addCriterion("transfer_remark not in", values, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkBetween(String value1, String value2) {
            addCriterion("transfer_remark between", value1, value2, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andTransferRemarkNotBetween(String value1, String value2) {
            addCriterion("transfer_remark not between", value1, value2, "transferRemark");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterionForJDBCDate("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterionForJDBCDate("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterionForJDBCDate("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterionForJDBCDate("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}